package com.bs.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.bs.entity.AdminInfo;
import org.apache.ibatis.annotations.*;
import org.springframework.beans.factory.annotation.Autowired;

import java.util.List;


@Mapper
public interface AdminInfoMapper extends BaseMapper<AdminInfo> {

//    @Select("SELECT * FROM admin_info WHERE id = #{id}")
//    AdminInfo selectById(Integer id);
//
//    @Select("SELECT * FROM admin_info WHERE 1 = 1")
//    List<AdminInfo> selectAll();
//
//    @Insert("INSERT INTO admin_info(name,department,job) VALUES (#{name},#{department},#{job})")
//    int insert(AdminInfo adminInfo);
//
//    @Update("UPDATE admin_info SET (name = #{name},department = #{department} ,job = #{job}) WHERE id = #{id}")
//    Integer updateAdmin(AdminInfo adminInfo);
//
//    @Delete("DELETE FROM admin_info WHERE id = #{id}")
//    Integer deleteAdmin(@Param("id") Integer id);
////
//    @Select("SELECT * FROM admin_info  WHERE name LIKE #{name} LIMIT #{pageNum},#{pageSize}")
//    List<AdminInfo> findPage(Integer pageNum, Integer pageSize, String name);
//
//    @Select("SELECT COUNT(*) FROM admin_info  WHERE name LIKE #{name}")
//    Integer totalNum(String name);
}
